www.gusucode.com > VC++ 客户管理系统(SQL Serve)-源码程序 > VC++ 客户管理系统(SQL Serve)-源码程序/code/Program/tsm.cpp

    // tsm.cpp : implementation file
//

#include "stdafx.h"
#include "khmanager.h"
#include "tsm.h"
#include "ado.h"
#include "khts.h"

#ifdef _DEBUG
#define new DEBUG_NEW
#undef THIS_FILE
static char THIS_FILE[] = __FILE__;
#endif

/////////////////////////////////////////////////////////////////////////////
// tsm dialog


tsm::tsm(CWnd* pParent /*=NULL*/)
	: CDialog(tsm::IDD, pParent)
{
	//{{AFX_DATA_INIT(tsm)
		// NOTE: the ClassWizard will add member initialization here
	//}}AFX_DATA_INIT
}


void tsm::DoDataExchange(CDataExchange* pDX)
{
	CDialog::DoDataExchange(pDX);
	//{{AFX_DATA_MAP(tsm)
	DDX_Control(pDX, IDC_LIST1, m_list);
	DDX_Control(pDX, IDC_COMBO1, m_com);
	//}}AFX_DATA_MAP
}


BEGIN_MESSAGE_MAP(tsm, CDialog)
	//{{AFX_MSG_MAP(tsm)
	ON_BN_CLICKED(IDC_BUTTON1, OnButton1)
	ON_BN_CLICKED(IDC_BUTTON2, OnButton2)
	ON_NOTIFY(NM_DBLCLK, IDC_LIST1, OnDblclkList1)
	ON_NOTIFY(LVN_COLUMNCLICK, IDC_LIST1, OnColumnclickList1)
	//}}AFX_MSG_MAP
END_MESSAGE_MAP()

/////////////////////////////////////////////////////////////////////////////
// tsm message handlers

BOOL tsm::OnInitDialog() 
{
	CDialog::OnInitDialog();
	ado rst;
	rst.Open("select * from tb_Client_khmyd",adCmdText);
	int rstnum=rst.GetRecordCount();
	int i;
	for(i=1;i<=rstnum;i++)
	{
		this->m_com.AddString(rst.GetFieldValue("khmyd_myd"));
		rst.Move(i);
	}
	rst.close();
	m_list.ModifyStyle(0L,LVS_REPORT);
//	m_list.ModifyStyle(0L,LVS_SINGLESEL);
	m_list.ModifyStyle(0L,LVS_SHOWSELALWAYS);
	m_list.ModifyStyle(0L,LVS_NOSORTHEADER);
	m_list.SetExtendedStyle(LVS_EX_GRIDLINES|
		LVS_EX_FULLROWSELECT|
		LVS_EX_HEADERDRAGDROP|
		LVS_EX_ONECLICKACTIVATE);
	m_list.EnableAutomation();
	m_list.InsertColumn(0,"区域编号");
	m_list.InsertColumn(1,"区域名称");
	m_list.InsertColumn(2,"区域级别");
	m_list.InsertColumn(3,"区域重要程度");
	m_list.InsertColumn(4,"区域购买力描述");
	m_list.InsertColumn(5,"备注信息");
	m_list.SetColumnWidth(0,100);
	m_list.SetColumnWidth(1,100);
	m_list.SetColumnWidth(2,100);
	m_list.SetColumnWidth(3,100);
	m_list.SetColumnWidth(4,100);
	m_list.SetColumnWidth(5,100);
	return TRUE;  // return TRUE unless you set the focus to a control
	              // EXCEPTION: OCX Property Pages should return FALSE
}

void tsm::OnButton1() 
{
this->EndDialog(true);	
}
void tsm::loadlist()
{
	ado rst;
	rst.rstOpen("select * from tb_Client_khts");
	int recordcount=rst.GetRecordCount();
int ii;
for(ii=1;ii<=recordcount;ii++)
{
m_list.InsertItem(ii-1,"");
m_list.SetItemText(ii-1,0,rst.GetFieldValue("khts_id"));
m_list.SetItemText(ii-1,1,rst.GetFieldValue("khts_qymc"));
m_list.SetItemText(ii-1,2,rst.GetFieldValue("khts_tsr"));
m_list.SetItemText(ii-1,3,rst.GetFieldValue("khts_tszt"));
m_list.SetItemText(ii-1,4,rst.GetFieldValue("khts_tsnr"));
m_list.SetItemText(ii-1,5,rst.GetFieldValue("khts_tsrq"));
m_list.SetItemText(ii-1,6,rst.GetFieldValue("khts_clbf"));
m_list.SetItemText(ii-1,7,rst.GetFieldValue("khts_khmyd"));
m_list.SetItemText(ii-1,8,rst.GetFieldValue("khts_tsslr"));
m_list.SetItemText(ii-1,9,rst.GetFieldValue("khts_bz"));
rst.Move(ii);
}
rst.close();
}

void tsm::OnButton2() 
{
	this->m_list.DeleteAllItems();
CString com,sql;
this->m_com.GetWindowText(com);
if(com.IsEmpty())
{MessageBox("请选择","提示");
return;
}
sql.Format("select * from tb_Client_khts where khts_khmyd='%s'",com);	
ado rst;
rst.Open(sql,adCmdText);
int recordcount=rst.GetRecordCount();
int ii;
for(ii=1;ii<=recordcount;ii++)
{
m_list.InsertItem(ii-1,"");
m_list.SetItemText(ii-1,0,rst.GetFieldValue("khts_id"));
m_list.SetItemText(ii-1,1,rst.GetFieldValue("khts_qymc"));
m_list.SetItemText(ii-1,2,rst.GetFieldValue("khts_tsr"));
m_list.SetItemText(ii-1,3,rst.GetFieldValue("khts_tszt"));
m_list.SetItemText(ii-1,4,rst.GetFieldValue("khts_tsnr"));
m_list.SetItemText(ii-1,5,rst.GetFieldValue("khts_tsrq"));
m_list.SetItemText(ii-1,6,rst.GetFieldValue("khts_clbf"));
m_list.SetItemText(ii-1,7,rst.GetFieldValue("khts_khmyd"));
m_list.SetItemText(ii-1,8,rst.GetFieldValue("khts_tsslr"));
m_list.SetItemText(ii-1,9,rst.GetFieldValue("khts_bz"));
rst.Move(ii);
}
rst.close();
}

void tsm::OnDblclkList1(NMHDR* pNMHDR, LRESULT* pResult) 
{
	int i=m_list.GetHotItem();
	if(i<0)
	{return;}
	khts ts;
ts.edit1=this->m_list.GetItemText(i,0);
ts.edit2=this->m_list.GetItemText(i,1);
ts.edit3=this->m_list.GetItemText(i,2);
ts.edit4=this->m_list.GetItemText(i,3);
//ts.edit5=this->m_list.GetItemText(i,4);
ts.edit6=this->m_list.GetItemText(i,4);
ts.edit7=this->m_list.GetItemText(i,5);
ts.edit8=this->m_list.GetItemText(i,6);
	ts.DoModal();
	
	*pResult = 0;
}

void tsm::OnColumnclickList1(NMHDR* pNMHDR, LRESULT* pResult) 
{
	NM_LISTVIEW* pNMListView = (NM_LISTVIEW*)pNMHDR;
	// TODO: Add your control notification handler code here
	
	*pResult = 0;
}